{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Guidance","Inputs","Extract","Lists"],"not_rendered":{"charts":0,"images":4,"macros":0,"external_links":3,"defined_names":141,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Guidance","index":0,"n_rows":95,"n_cols":19,"rows_kept":95,"cut":false,"hidden":false,"merged":[[9,2,9,11],[5,2,6,5],[28,2,28,11],[93,1,93,12],[94,1,94,12],[69,2,69,11],[70,2,70,11],[63,2,63,11],[75,2,75,11],[76,2,76,11],[71,2,71,11],[72,2,72,11],[73,2,73,11],[74,2,74,11],[68,2,68,11],[13,2,13,11],[15,2,15,11],[42,2,42,11],[49,2,49,11],[43,2,43,11],[17,2,17,7],[37,2,37,11],[22,2,22,11],[24,2,24,11],[27,2,27,11],[29,2,29,11],[38,2,38,11],[41,2,41,11],[51,2,51,11],[40,2,40,11],[39,2,39,11],[50,2,50,11],[62,2,62,11],[61,2,61,11],[52,2,52,11],[59,2,59,11],[60,2,60,11],[55,2,55,11],[56,2,56,11],[57,2,57,11],[53,2,53,11],[58,2,58,11],[54,2,54,11],[44,2,44,11],[89,2,89,11],[90,2,90,11],[80,2,80,11],[81,2,81,11],[85,2,85,11]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"version 1","2011-01-13"]
[]
[]
[null,null,"Application for Individual Scheme Loan"]
[]
[null,null,"Guidance"]
[]
[]
[]
[null,null,"The Individual loan application form should only be completed by an Approved Housing Body \nthat has received approved borrower status from the Housing Finance Agency."]
[]
[null,null,"INTRODUCTION"]
[]
[null,"a","This application form must be completed in full if you wish to apply for an AHB loan for an individual development scheme."]
[]
[null,"b","The form is designed to collect data in a standard format in order that the HFA may review the financial standing of individual loan applications on a like for like basis."]
[]
[null,"c","Please complete all yellow filled cells, where relevant, e.g."]
[]
[null,"d","The form is set up with three sub-sections requesting data as follows:"]
[null,null,"Section 1 - Scheme Costs and Loan Data"]
[null,null,"Section 2 - Year 1 Income and Expenditure Assumptions"]
[null,null,"Section 3 - Economic Assumptions"]
[]
[null,"e","The form is set up with various links throughout to help you move to different sections / sheets with ease. The links are set up in two types of button formats or as hyperlinks."]
[null,null,"Button type one",null,null,"Button type two",null,null,null,"Hyperlinks"]
[]
[null,null,"Clicking on these linked buttons will take you a different section of the workbook."]
[null,"f","If you have any questions on completing this workbook please phone on 01-872 5722 or email us at"]
[null,null,"directlending@hfa.ie"]
[]
[]
[null,null,"GUIDANCE"]
[]
[null,null,"SECTION 1 - Scheme Costs and Loan Data"]
[]
[null,null,"The information requested in the scheme costs and loan requirement section is as follows:"]
[]
[null,"a","The number of units to be produced."]
[null,"b","The total scheme value as provided by an independent valuer."]
[null,"c","The total purchase cost of the scheme."]
[null,"d","Any other external capital subsidy or grant that applies to the scheme."]
[null,"e","Any internal subsidy that the AHB is providing to the scheme. This is where they are not borrowing the full purchase cost from the HFA but are partly funding the scheme from their own Reserves."]
[null,"f","The amount of loan requested from the HFA (€)."]
[null,"g","The term of the loan requested from the HFA (e.g. 25 years)."]
[]
[null,null,"SECTION 2 - Year 1 Income and Expenditure Data"]
[]
[null,null,"The information requested in the year 1 income and expenditure data is as follows:"]
[]
[null,"a","The total Availability Payment per year to be received from the local authority. It is expected that this will correlate with the copy of the actual Payment and Availability Agreement that the AHB is required to supply."]
[null,"b","Input the Term in years of the Payment and Availability Agreement."]
[null,"c","Input the number of years between adjustments to the Availability Payment as set out in Second Schedule of the Payment and Availability Agreement."]
[null,"d","Input the gross market rent per annum from which the Availability Payment is calculated. "]
[null,"e","Input the average differential rent to be charged by the AHB to the tenant each week."]
[null,"f","The voids and bad debts allowance to be applied to a) the Availability Payment and b) the differential rent."]
[null,"g","Input any other income expected on the scheme such as service charges from tenants, support grants from the HSE."]
[null,"h","Input the total management costs per unit expected to be incurred in year 1."]
[null,"i","Input the reactive and void maintenance costs per unit in year 1."]
[null,"j","Input the cyclical costs per unit in year 1 and select whether they are incurred annually or at 5 yearly intervals."]
[null,"k","Input the annual sinking fund transfer as a % of differential rent (if applicable) and select whether this represents an actual cash out flow (\"cash backed\") or a transfer to a sinking fund reserve."]
[null,"l","If the sinking fund is not used or is assumed not to be \"cash backed\" input details of future life cycle costs here. Life cycle costs can also be labelled major repairs, planned maintenance or stock condition costs. "]
[null,null,"Note that the figures input should be in todays prices and not include inflation. Also note that the year the cost is incurred can be changed."]
[null,"m","Details of any other expenditure assumptions such as service charges paid to management companies."]
[]
[null,null,"SECTION 3 - Economic Assumptions",null,null,null,null,null,null,"Go to section 3 "]
[]
[null,null,"The information requested in the economic assumptions sub-section is as set out below. "]
[]
[null,"a","Input the discount rate used in the NPV calculation."]
[null,"b","Input the assumptions for the interest rate on the HFA loan in the relevant years or bands of years."]
[null,"c","Input the assumption used for the Consumer Price Index Rental Sub-Indices that will be used to increase the Availability Payment at regular intervals."]
[".","d","Input the assumptions for annual inflationary increases on differential rents"]
[null,"e","Input the assumptions for annual inflationary increases in other income."]
[null,"f","Input the assumptions for annual inflationary increases in management costs."]
[null,"g","Input the assumptions for annual inflationary increases in maintenance costs."]
[null,"h","Input the assumptions for annual inflationary increases in other costs."]
[]
[null,null,"SECTION 4 - Additional information checklist"]
[]
[null,"a","Please confirm that you have submitted all information listed. If you are unable to submit any item listed or have any comments on the information submitted please detail in the comments box next to the item."]
[null,"b","All documents must be submitted in hard copy either as an original or as a copy certified by the signatories under section 5 of this application."]
[]
[null,null,"SECTION 5 - Contact information"]
[]
[null,"a","Please provide a primary and secondary contact for the HFA in respect of any queries on this application."]
[null,null,null,null,null,null,null,null,null,"Go to section 4 "]
[null,null,"SECTION 6 - Declaration",null,null,null,null,null,null,null,"Go to section 9"]
[]
[null,"a","This section must be completed by a signatory or signatories legally authorised to apply for loans on behalf of the organisation."]
[null,"b","Completion of this application with deliberately or negligently inaccurate or misleading data or by unauthorised signatories will invalidate this application and any rights of the applicant under any document or arrangement entered into as a result of this application."]
[]
[]
[null,"Once complete please email the application form and supporting documentation to "]
[null,"directlending@hfa.ie"]

{"sheet":"Inputs","index":1,"n_rows":209,"n_cols":8,"rows_kept":209,"cut":false,"hidden":false,"merged":[[8,5,8,7],[21,5,21,7],[36,5,36,7],[95,5,95,7],[162,5,162,7],[173,5,173,7],[121,1,121,3],[122,1,122,3],[123,1,123,3],[124,1,124,3],[127,1,127,3],[97,1,97,3],[100,1,100,3],[101,1,101,3],[102,1,102,3],[103,1,103,3],[120,1,120,3],[93,1,93,2],[75,1,75,2],[80,1,80,3],[165,1,165,7],[168,4,168,7],[169,4,169,7],[48,1,48,2],[50,1,50,2],[51,1,51,2],[53,1,53,2],[55,3,55,4],[55,1,55,2],[158,1,158,3],[159,1,159,3],[160,1,160,3],[131,1,131,3],[132,1,132,3],[133,1,133,3],[136,1,136,3],[137,1,137,3],[138,1,138,3],[139,1,139,3],[150,1,150,3],[151,1,151,3],[154,1,154,3],[155,1,155,3],[74,1,74,2],[56,3,56,4],[81,1,81,3],[156,1,156,3],[157,1,157,3],[7,5,7,7],[20,5,20,7],[35,5,35,7],[94,5,94,7],[164,1,164,7],[149,1,149,3],[84,1,84,2],[85,1,85,2],[104,1,104,3],[105,1,105,3],[106,1,106,3],[112,1,112,3],[113,1,113,3],[114,1,114,3],[140,1,140,3],[141,1,141,3],[128,1,128,3],[129,1,129,3],[130,1,130,3],[10,2,10,4],[12,2,12,4],[14,2,14,4],[15,2,15,4],[16,2,16,4],[6,1,6,4],[7,3,7,4],[20,3,20,4],[115,1,115,3],[118,1,118,3],[119,1,119,3],[109,1,109,3],[110,1,110,3],[111,1,111,3],[56,1,56,2],[58,1,58,2],[60,1,60,2],[61,1,61,2],[86,1,86,2],[87,1,87,2],[88,1,88,2],[89,1,89,2],[92,1,92,2],[77,1,77,3],[63,1,63,2],[66,1,66,2],[67,1,67,2],[70,1,70,2],[71,1,71,2],[17,2,17,4],[18,2,18,4],[19,2,19,4],[46,1,46,2],[34,2,34,4],[38,1,38,2],[40,1,40,2],[42,3,42,4],[42,1,42,2],[44,1,44,2],[44,3,44,4],[23,2,23,4],[25,2,25,4],[27,2,27,4],[29,2,29,4],[30,2,30,4],[32,2,32,4],[178,2,178,7],[185,5,185,7],[175,2,175,3],[176,2,176,3],[177,2,177,3],[180,2,180,3],[181,2,181,3],[182,2,182,3],[183,2,183,7],[142,1,142,3],[145,1,145,3],[146,1,146,3],[147,1,147,3],[148,1,148,3],[208,1,208,2],[208,3,208,4],[192,1,192,6],[189,1,189,7],[190,1,190,7],[198,1,198,2],[198,3,198,4],[199,1,199,2],[199,3,199,4],[194,1,196,4],[201,1,203,4],[187,1,187,7],[188,1,188,7],[170,4,170,7],[171,4,171,7],[205,1,205,2],[205,3,205,4],[206,1,206,2],[206,3,206,4]]}
[]
[]
[]
[]
[]
[]
[null,"Application for Individual Scheme Loan"]
[]
[null,"General information",null,null,null,"Return to guidance section"]
[]
[null,"Approved Housing Body Name:"]
[]
[null,"Name of Scheme:"]
[]
[null,"Scheme Address:"]
[]
[]
[]
[]
[]
[]
[null,"SECTION 1 - SCHEME COSTS AND LOAN DATA",null,null,null,"Return to guidance section"]
[]
["a","Number of Units"]
[]
["b","The total scheme value as provided by an independent valuer (€)"]
[]
["c","Total Purchase/Build Cost of Scheme (€)"]
[]
["d","Capital Subsidy from external sources (€)"]
["e","Internal Capital Subsidy or Equity (€)"]
[]
["f","The amount of loan requested from the HFA (€)",{"$f":"C28-C30-C31","v":0}]
[]
[null,"The term of the loan requested by the HFA (years)"]
[]
[null,"SECTION 2 - YEAR 1 INCOME AND EXPENDITURE DATA",null,null,null,"Return to guidance section"]
[]
[null,"Availability Payments",null,"Per unit","Scheme total"]
[]
[null,"Total Availability Payment per annum",null,{"$f":"IF(Units>0,E41/Units,0)","v":0}]
[]
[null,"Term of the Payment and Availability Agreement (years)"]
[]
[null,"Years between \"Adjustments\" to AP per Schedule 2",null,"Select"]
[]
[null,"Market Rent per Year",null,{"$f":"IF(Units>0,E47/Units,0)","v":0}]
[]
[null,"Differential Rents"]
[]
[null,"Differential rent per week per tenant",null,"Per unit :"]
[null,"Differential rent per year",null,"Total :",{"$f":"E51*Units*52","v":0}]
[]
[null,"Voids and Bad Debts"]
[]
[null,"Voids & Bad Debts on Availability Payment"]
[null,"Voids & Bad Debts on Differential Rent"]
[]
[null,"Other Income"]
[]
[null,"Input details of any other income per unit per year e.g. grants",null,"Per unit :"]
[null,{"$f":"B59&\" total in year 1\"","v":"Other Income total in year 1"},null,"Total :",{"$f":"E61*Units","v":0}]
[]
[null,"Management and Maintenance Costs"]
[]
[null,"Management costs"]
[null,"Input details of management costs per unit per year",null,"Per unit :"]
[null,"Management costs total in year 1",null,"Total :",{"$f":"E67*Units","v":0}]
[]
[null,"Reactive and void maintenance costs"]
[null,"Input details of reactive and voids maintenance costs per unit per year",null,"Per unit :"]
[null,{"$f":"B70&\" total in year 1\"","v":"Reactive and void maintenance costs total in year 1"},null,"Total :",{"$f":"E71*Units","v":0}]
[]
[null,"Cyclical maintenance costs"]
[null,"Input details of cyclical maintenance costs per unit per year",null,"Per unit :"]
[null,{"$f":"B74&\" total in year 1\"","v":"Cyclical maintenance costs total in year 1"},null,"Total :",{"$f":"E75*Units","v":0}]
[]
[null,"Choose if cyclical maintenance costs are assumed to be incurred annually or at 5 yearly intervals",null,null,"Select"]
[]
[null,"Sinking Fund"]
[null,"Sinking Fund as % of Differential Rent"]
[null,"Cash backed or Reserve Movement ?",null,null,"Select"]
[]
[null,"Life cycle costs (only required if sinking fund is a Reserve Movement)",null,"Year","Scheme total"]
[null,"Life Cycle Spend in year"]
[null,"Life Cycle Spend in year"]
[null,"Life Cycle Spend in year"]
[null,"Life Cycle Spend in year"]
[null,"Life Cycle Spend in year"]
[null,"Life Cycle Spend in year"]
[]
[null,"Other Costs"]
[null,"Input details of any other costs per unit per year e.g. service charges paid",null,"Per unit :"]
[null,{"$f":"B92&\" total in year 1\"","v":"Other Costs total in year 1"},null,"Total :",{"$f":"E93*Units","v":0}]
[]
[null,"SECTION 3 - ECONOMIC ASSUMPTIONS",null,null,null,"Return to guidance section"]
[]
[null,"Discount rate used for NPV"]
[]
[null,"Interest Rate % per year"]
[null,"Input the interest rate assumed in year 1"]
[null,"Input the interest rate assumed in year 2"]
[null,"Input the interest rate assumed in year 3"]
[null,"Input the interest rate assumed in year 4"]
[null,"Input the interest rate assumed in year 5"]
[null,"Input the interest rate assumed in years 6 to 15"]
[null,{"$f":"\"Input the interest rate assumed in years 16 to \"&No_of_years","v":"Input the interest rate assumed in years 16 to "}]
[]
[null,"Consumer Price Index Rental Sub-Indices Input"]
[null,"Input the CPI rents indice assumed in year 1",null,null,0]
[null,"Input the CPI rents indice assumed in year 2"]
[null,"Input the CPI rents indice assumed in year 3"]
[null,"Input the CPI rents indice assumed in year 4"]
[null,"Input the CPI rents indice assumed in year 5"]
[null,"Input the CPI rents indice assumed in years 6 to 15"]
[null,{"$f":"\"Input the CPI rents indice assumed in years 16 to \"&No_of_years","v":"Input the CPI rents indice assumed in years 16 to "}]
[]
[null,"Rent increases on Differential Rent"]
[null,"Input the differential rent increase assumed in year 1",null,null,0]
[null,"Input the differential rent increase assumed in year 2"]
[null,"Input the differential rent increase assumed in year 3"]
[null,"Input the differential rent increase assumed in year 4"]
[null,"Input the differential rent increase assumed in year 5"]
[null,"Input the differential rent increase assumed in years 6 to 15"]
[null,{"$f":"\"Input the differential rent increase assumed in years 16 to \"&No_of_years","v":"Input the differential rent increase assumed in years 16 to "}]
[]
[null,"Other Income % increase per year"]
[null,"Input the other income inflation assumed in year 1",null,null,0]
[null,"Input the other income inflation assumed in year 2"]
[null,"Input the other income inflation assumed in year 3"]
[null,"Input the other income inflation assumed in year 4"]
[null,"Input the other income inflation assumed in year 5"]
[null,"Input the other income inflation assumed in year 6 to 15"]
[null,{"$f":"\"Input the other income inflation assumed in years 16 to \"&No_of_years","v":"Input the other income inflation assumed in years 16 to "}]
[]
[null,"Management Cost  % increase per year"]
[null,"Input the management costs inflation assumed in year 1",null,null,0]
[null,"Input the management costs inflation assumed in year 2"]
[null,"Input the management costs inflation assumed in year 3"]
[null,"Input the management costs inflation assumed in year 4"]
[null,"Input the management costs inflation assumed in year 5"]
[null,"Input the management costs inflation assumed in years 6 to 15"]
[null,{"$f":"\"Input the management costs inflation assumed in years 16 to \"&No_of_years","v":"Input the management costs inflation assumed in years 16 to "}]
[]
[null,"Maintenance Cost  % increase per year"]
[null,"Input the maintenance costs inflation assumed in year 1",null,null,0]
[null,"Input the maintenance costs inflation assumed in year 2"]
[null,"Input the maintenance costs inflation assumed in year 3"]
[null,"Input the maintenance costs inflation assumed in year 4"]
[null,"Input the maintenance costs inflation assumed in year 5"]
[null,"Input the maintenance costs inflation assumed in years 6 to 15"]
[null,{"$f":"\"Input the maintenance costs inflation assumed in years 16 to \"&No_of_years","v":"Input the maintenance costs inflation assumed in years 16 to "}]
[]
[null,"Other Cost % increase per year"]
[null,"Input the other costs inflation assumed in year 1",null,null,0]
[null,"Input the other costs inflation assumed in year 2"]
[null,"Input the other costs inflation assumed in year 3"]
[null,"Input the other costs inflation assumed in year 4"]
[null,"Input the other costs inflation assumed in year 5"]
[null,"Input the other costs inflation assumed in years 6 to 15"]
[null,{"$f":"\"Input the other costs inflation assumed in years 16 to \"&No_of_years","v":"Input the other costs inflation assumed in years 16 to "}]
[]
[null,"SECTION 4  - ADDITIONAL INFORMATION",null,null,null,"Return to guidance section"]
[]
[null,"When submitting your application please confirm in the boxes provide below that you have included the following additional information required."]
[null,"All documents submitted should either be originals or copies certifed by an authorised officer."]
[]
[null,null,"Submitted",null,"Comments on other information submitted"]
[null,"Evidence of level of Availability Payments \nDraft Payment and Availability Agreement or letter from local authority  with details of proposed Availability Payments","Select"]
[null,"Copy of standard tenancy agreement to be used for properties acquired","Select"]
[null,"Valuation report of properties to be acquired","Select"]
[null,"Structural survey of properties to be acquired","Select"]
[]
[null,"SECTION 5 - CONTACT INFORMATION",null,null,null,"Return to guidance section"]
[]
[null,"Primary contact person :"]
[null,"Primary contact job title :"]
[null,"Primary contact telephone number :"]
[null,"Primary contact email address :"]
[]
[null,"Secondary contact person :"]
[null,"Secondary contact job title :"]
[null,"Secondary contact telephone number :"]
[null,"Secondary contact email address :"]
[]
[null,"SECTION 6 - DECLARATION",null,null,null,"Return to guidance section"]
[]
[null,{"$f":"IF(AHB=\"\",\"I declare that the above information is accurate and complete and that I am appropriately authorised by the Board (name incomplete) to sign on behalf of the\",\"I declare that the above information is accurate and complete and that I am appropriately authorised by the Board of \"&AHB&\" to sign on behalf of the\")","v":"I declare that the above information is accurate and complete and that I am appropriately authorised by the Board (name incomplete) to sign on behalf of the"}]
[null,"organisation to apply for a HFA individual scheme loan."]
[null,"Completion of this application with deliberately or negligently inaccurate or misleading data or by unauthorised signatories will invalidate this application"]
[null,"and any rights of the applicant, any document or arrangement entered into as a result of this application."]
[]
[null,"In submitting this application for an Individual Scheme Loan we confirm that the information contained within this application is materially  correct and accurate, and we also confirm that we are not aware of any known reasons that may preclude us from entering into a loan arrangement with the Housing Finance Agency plc.",null,null,null,null,null,"Select"]
[]
[]
[]
[]
[null,"Signature 1"]
[null,"Name :"]
[null,"Job title :"]
[]
[]
[]
[]
[null,"Signature 2, if necessary"]
[null,"Name :"]
[null,"Job title :"]
[]
[null,"Application date :"]

{"sheet":"Extract","index":2,"n_rows":176,"n_cols":3,"rows_kept":176,"cut":false,"hidden":true,"merged":[]}
["Housing Finance Agency plc."]
["Extracts for Individual Loan Assessment Model"]
[]
[{"$f":"+Inputs!B9","v":"General information"}]
[]
[]
["Approved Housing Body Name:",null,{"$f":"Inputs!C11","v":0}]
[]
["Name of Scheme:",null,{"$f":"Inputs!C13","v":0}]
[]
["Scheme Address:",null,{"$f":"Inputs!C16","v":0}]
[null,null,{"$f":"Inputs!C17","v":0}]
[null,null,{"$f":"Inputs!C18","v":0}]
[null,null,{"$f":"Inputs!C19","v":0}]
[null,null,{"$f":"Inputs!C20","v":0}]
[]
[]
["SECTION 1 - SCHEME COSTS AND LOAN DATA"]
[]
["Number of Units",null,{"$f":"Inputs!C24","v":0}]
[]
["The total scheme value as provided by an independent valuer",null,{"$f":"Inputs!C26","v":0}]
[]
["Total Purchase/Build Cost of Scheme",null,{"$f":"Inputs!C28","v":0}]
[]
["Capital Subsidy from external sources",null,{"$f":"Inputs!C30","v":0}]
["Internal Capital Subsidy or Equity",null,{"$f":"Inputs!C31","v":0}]
[]
[{"$f":"Guidance!C44","v":"The amount of loan requested from the HFA (€)."},null,{"$f":"Inputs!C33","v":0}]
[]
["The term of the loan requested by the HFA",null,{"$f":"Inputs!C35","v":0}]
[]
["SECTION 2 - YEAR 1 INCOME AND EXPENDITURE DATA"]
[]
[]
["Total Availability Payment per annum",null,{"$f":"Inputs!E41","v":0}]
[]
["Term of the Payment and Availability Agreement",null,{"$f":"Inputs!D43","v":0}]
[]
["Years between \"Adjustments\" to AP per Schedule 2",null,{"$f":"Inputs!D45","v":"Select"}]
[]
["Market Rent per Year",null,{"$f":"Inputs!E47","v":0}]
[]
["Differential rent per week per tenant",null,{"$f":"Inputs!E51","v":0}]
["Differential Rent per Year",null,{"$f":"Inputs!E52","v":0}]
[]
["Voids & Bad Debts on Availability Payment",null,{"$f":"Inputs!D56","v":0}]
["Voids & Bad Debts on Differential Rent",null,{"$f":"Inputs!D57","v":0}]
[]
["Input details of any other income e.g. grants","per unit",{"$f":"Inputs!E61","v":0}]
["Other Income total in year 1","Total",{"$f":"Inputs!E62","v":0}]
[]
["Management and Maintenance Costs"]
[]
["Management costs"]
["Input details of management costs","per unit",{"$f":"Inputs!E67","v":0}]
["Management costs total in year 1","Total",{"$f":"Inputs!E68","v":0}]
[]
["Reactive and void maintenance costs"]
["Input details of reactive and voids maintenance costs","per unit",{"$f":"Inputs!E71","v":0}]
["Reactive and void maintenance costs total in year 1","Total",{"$f":"Inputs!E72","v":0}]
[]
["Cyclical maintenance costs"]
["Input details of cyclical maintenance costs per unit","per unit",{"$f":"Inputs!E75","v":0}]
["Cyclical maintenance costs total in year 1","Total",{"$f":"Inputs!E76","v":0}]
[]
["Choose if cyclical maintenance costs are assumed to be incurred annually or at 5 yearly intervals",null,{"$f":"Inputs!E78","v":"Select"}]
[]
["Sinking Fund"]
["Sinking Fund as % of Differential Rent",null,{"$f":"Inputs!E81","v":0}]
["Cash or Reserve Movement ?",null,{"$f":"Inputs!E82","v":"Select"}]
[]
["Life cycle costs","Year","Total"]
["Life Cycle Spend in year",{"$f":"Inputs!D85","v":0},{"$f":"Inputs!E85","v":0}]
["Life Cycle Spend in year",{"$f":"Inputs!D86","v":0},{"$f":"Inputs!E86","v":0}]
["Life Cycle Spend in year",{"$f":"Inputs!D87","v":0},{"$f":"Inputs!E87","v":0}]
["Life Cycle Spend in year",{"$f":"Inputs!D88","v":0},{"$f":"Inputs!E88","v":0}]
["Life Cycle Spend in year",{"$f":"Inputs!D89","v":0},{"$f":"Inputs!E89","v":0}]
["Life Cycle Spend in year",{"$f":"Inputs!D90","v":0},{"$f":"Inputs!E90","v":0}]
[]
["Other Costs"]
["Input details of any other costs e.g. service charges paid","per unit",{"$f":"Inputs!E93","v":0}]
[{"$f":"A81&\" total in year 1\"","v":"Other Costs total in year 1"},"Total",{"$f":"Inputs!E94","v":0}]
[]
["SECTION 3 - ECONOMIC ASSUMPTIONS"]
[]
["Discount rate used for NPV",null,{"$f":"Inputs!E98","v":0}]
[]
["Interest Rate % per year",null,"%"]
["Input the interest rate assumed in year 1",null,{"$f":"Inputs!E101","v":0}]
["Input the interest rate assumed in year 2",null,{"$f":"Inputs!E102","v":0}]
["Input the interest rate assumed in year 3",null,{"$f":"Inputs!E103","v":0}]
["Input the interest rate assumed in year 4",null,{"$f":"Inputs!E104","v":0}]
["Input the interest rate assumed in year 5",null,{"$f":"Inputs!E105","v":0}]
["Input the interest rate assumed in years 6 to 15",null,{"$f":"Inputs!E106","v":0}]
[{"$f":"\"Input the interest rate assumed in years 16 to \"&No_of_years","v":"Input the interest rate assumed in years 16 to "},null,{"$f":"Inputs!E107","v":0}]
[]
["Consumer Price Index Rental Sub-Indices Input",null,"%"]
["Input the CPI rents indice assumed in year 1",null,{"$f":"Inputs!E110","v":0}]
["Input the CPI rents indice assumed in year 2",null,{"$f":"Inputs!E111","v":0}]
["Input the CPI rents indice assumed in year 3",null,{"$f":"Inputs!E112","v":0}]
["Input the CPI rents indice assumed in year 4",null,{"$f":"Inputs!E113","v":0}]
["Input the CPI rents indice assumed in year 5",null,{"$f":"Inputs!E114","v":0}]
["Input the CPI rents indice assumed in years 6 to 15",null,{"$f":"Inputs!E115","v":0}]
[{"$f":"\"Input the CPI rents indice assumed in years 16 to \"&No_of_years","v":"Input the CPI rents indice assumed in years 16 to "},null,{"$f":"Inputs!E116","v":0}]
[]
["Rent increases on Differential Rent",null,"%"]
["Input the differential rent increase assumed in year 1",null,{"$f":"Inputs!E119","v":0}]
["Input the differential rent increase assumed in year 2",null,{"$f":"Inputs!E120","v":0}]
["Input the differential rent increase assumed in year 3",null,{"$f":"Inputs!E121","v":0}]
["Input the differential rent increase assumed in year 4",null,{"$f":"Inputs!E122","v":0}]
["Input the differential rent increase assumed in year 5",null,{"$f":"Inputs!E123","v":0}]
["Input the differential rent increase assumed in years 6 to 15",null,{"$f":"Inputs!E124","v":0}]
[{"$f":"\"Input the differential rent increase assumed in years 16 to \"&No_of_years","v":"Input the differential rent increase assumed in years 16 to "},null,{"$f":"Inputs!E125","v":0}]
[]
["Other Income % increase per year",null,"%"]
["Input the interest rate assumed in year 1",null,{"$f":"Inputs!E128","v":0}]
["Input the interest rate assumed in year 2",null,{"$f":"Inputs!E129","v":0}]
["Input the interest rate assumed in year 3",null,{"$f":"Inputs!E130","v":0}]
["Input the interest rate assumed in year 4",null,{"$f":"Inputs!E131","v":0}]
["Input the interest rate assumed in year 5",null,{"$f":"Inputs!E132","v":0}]
["Input the interest rate assumed in years 6 to 15",null,{"$f":"Inputs!E133","v":0}]
[{"$f":"\"Input the interest rate assumed in years 16 to \"&No_of_years","v":"Input the interest rate assumed in years 16 to "},null,{"$f":"Inputs!E134","v":0}]
[]
["Management Cost  % increase per year",null,"%"]
["Input the management costs inflation assumed in year 1",null,{"$f":"Inputs!E137","v":0}]
["Input the management costs inflation assumed in year 2",null,{"$f":"Inputs!E138","v":0}]
["Input the management costs inflation assumed in year 3",null,{"$f":"Inputs!E139","v":0}]
["Input the management costs inflation assumed in year 4",null,{"$f":"Inputs!E140","v":0}]
["Input the management costs inflation assumed in year 5",null,{"$f":"Inputs!E141","v":0}]
["Input the management costs inflation assumed in years 6 to 15",null,{"$f":"Inputs!E142","v":0}]
[{"$f":"\"Input the management costs inflation assumed in years 16 to \"&No_of_years","v":"Input the management costs inflation assumed in years 16 to "},null,{"$f":"Inputs!E143","v":0}]
[]
["Maintenance Cost  % increase per year",null,"%"]
["Input the maintenance costs inflation assumed in year 1",null,{"$f":"Inputs!E146","v":0}]
["Input the maintenance costs inflation assumed in year 2",null,{"$f":"Inputs!E147","v":0}]
["Input the maintenance costs inflation assumed in year 3",null,{"$f":"Inputs!E148","v":0}]
["Input the maintenance costs inflation assumed in year 4",null,{"$f":"Inputs!E149","v":0}]
["Input the maintenance costs inflation assumed in year 5",null,{"$f":"Inputs!E150","v":0}]
["Input the maintenance costs inflation assumed in years 6 to 15",null,{"$f":"Inputs!E151","v":0}]
[{"$f":"\"Input the maintenance costs inflation assumed in years 16 to \"&No_of_years","v":"Input the maintenance costs inflation assumed in years 16 to "},null,{"$f":"Inputs!E152","v":0}]
[]
["Other Cost % increase per year",null,"%"]
["Input the other costs inflation assumed in year 1",null,{"$f":"Inputs!E155","v":0}]
["Input the other costs inflation assumed in year 2",null,{"$f":"Inputs!E156","v":0}]
["Input the other costs inflation assumed in year 3",null,{"$f":"Inputs!E157","v":0}]
["Input the other costs inflation assumed in year 4",null,{"$f":"Inputs!E158","v":0}]
["Input the other costs inflation assumed in year 5",null,{"$f":"Inputs!E159","v":0}]
["Input the other costs inflation assumed in years 6 to 15",null,{"$f":"Inputs!E160","v":0}]
[{"$f":"\"Input the other costs inflation assumed in years 16 to \"&No_of_years","v":"Input the other costs inflation assumed in years 16 to "},null,{"$f":"Inputs!E161","v":0}]
[]
[]
[{"$f":"+Inputs!B163","v":"SECTION 4  - ADDITIONAL INFORMATION"}]
[]
[{"$f":"+Inputs!B169","v":"Evidence of level of Availability Payments \nDraft Payment and Availability Agreement or letter from local authority  with details of proposed Availability Payments"},{"$f":"+Inputs!C169","v":"Select"},{"$f":"+Inputs!E169","v":0}]
[{"$f":"+Inputs!B170","v":"Copy of standard tenancy agreement to be used for properties acquired"},{"$f":"+Inputs!C170","v":"Select"},{"$f":"+Inputs!E170","v":0}]
[{"$f":"+Inputs!B171","v":"Valuation report of properties to be acquired"},{"$f":"+Inputs!C171","v":"Select"},{"$f":"+Inputs!E171","v":0}]
[{"$f":"+Inputs!B172","v":"Structural survey of properties to be acquired"},{"$f":"+Inputs!C172","v":"Select"},{"$f":"+Inputs!E172","v":0}]
[]
[]
[{"$f":"+Inputs!B174","v":"SECTION 5 - CONTACT INFORMATION"}]
[]
[{"$f":"+Inputs!B176","v":"Primary contact person :"},{"$f":"+Inputs!C176","v":0}]
[{"$f":"+Inputs!B177","v":"Primary contact job title :"},{"$f":"+Inputs!C177","v":0}]
[{"$f":"+Inputs!B178","v":"Primary contact telephone number :"},{"$f":"+Inputs!C178","v":0}]
[{"$f":"+Inputs!B179","v":"Primary contact email address :"},{"$f":"+Inputs!C179","v":0}]
[]
[{"$f":"+Inputs!B181","v":"Secondary contact person :"},{"$f":"Inputs!C181","v":0}]
[{"$f":"+Inputs!B182","v":"Secondary contact job title :"},{"$f":"Inputs!C182","v":0}]
[{"$f":"+Inputs!B183","v":"Secondary contact telephone number :"},{"$f":"Inputs!C183","v":0}]
[{"$f":"+Inputs!B184","v":"Secondary contact email address :"},{"$f":"Inputs!C184","v":0}]
[]
[]
[{"$f":"+Inputs!B186","v":"SECTION 6 - DECLARATION"}]
[]
[{"$f":"+Inputs!B193","v":"In submitting this application for an Individual Scheme Loan we confirm that the information contained within this application is materially  correct and accurate, and we also confirm that we are not aware of any known reasons that may preclude us from entering into a loan arrangement with the Housing Finance Agency plc."},null,{"$f":"+Inputs!H193","v":"Select"}]

{"sheet":"Lists","index":3,"n_rows":17,"n_cols":2,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"SinkingFund"]
[null,"Select"]
[null,"Cash"]
[null,"Reserve movement"]
[]
[null,"TimePeriod"]
[null,"Select"]
[null,"Annual"]
[null,"Five yearly"]
[]
[null,"YearsAdjustments"]
[null,"Select"]
[null,3]
[null,4]
[null,5]